Setting Object Permissions

In SQL Server 2005 or above, to edit the specific object permission of this database role, click Add Permission to open the window and follow the steps below:

(1) Expand the node in the tree view until reaching to the target object.
(2) Check the object to show the grid on the right panel.
(3) In the grid, check Grant, Grant Option or Deny against the permission listed in Permission to assign this database role to have that permission. Multiple permissions can be granted.

To grant (select) or revoke (unselect) all permissions, control-click the grid and select Grant All, Grant All With Grant Option, Deny All or Revoke All option.

Note: Click Add to apply permission settings.